import pandas as pd
from scipy.special import gamma

wD = pd.read_excel('WindData_whole.xls')

It={'It_70m':0,'It_60m':0,'It_50m':0,'It_30m':0,'It_10m':0}

#计算湍流强度
i=1
for high in It:
    SD='CH'+str(i)+'SD'
    Avg='CH'+str(i)+'Avg'
    It[high]=(wD[SD]/wD[Avg]).mean()
    i+=1
    print(It[high])







